create table Job_class (
   classId              int                  identity,
   className            nvarchar(50)         null,
   classDesc            nvarchar(255)        null,
   constraint PK_JOB_CLASS primary key (classId)
)

go

create table Job (
   id                   int                  not null,
   classId              int                  null,
   jobName              nvarchar(255)        null,
   count                int                  null,
   sex                  char(2)              null,
   education            nvarchar(50)         null,
   address              nvarchar(50)         null,
   "desc"               nvarchar(255)        null,
   requirements         nchar(255)           null,
   remarks              nvarchar(255)        null,
   issue                nvarchar(10)         null,
   deployDate           datetime             null,
   email                nvarchar(50)         null,
   penone               nvarchar(50)         null,
   constraint PK_JOB primary key (id)
)
go

alter table Job
   add constraint FK_JOB_REFERENCE_JOB_CLAS foreign key (classId)
      references Job_class (classId)
go